Termininiranje sesije

Identifikacija korisničkog imena na osnovu izvršene komande

SQL> select PARSING_SCHEMA_NAME,SQL_TEXT from v$sql where upper(sql_text) like '%PQ_SESSTAT%' and PARSING_SCHEMA_NAME!='SYS'

PARSING_SCHEMA_NAME SQL_TEXT

-------------------------------------------------------------------------------------------------

SCOTT select * from v$pq_sesstat

SQL>select sid,serial#,terminal,username,program from v$session where username='SCOTT';

SID SERIAL# TERMINAL USERNAME PROGRAM

---------- ---------- ---------------- ------------------------------ ------------------

127 10168 SCOTT SQL Developer

131 28278 INFO3 SCOTT TOAD.exe

134 48423 SCOTT SQL Developer

154 42592 ORA10GFS SCOTT sqlplus.exe

(Uslov je da aktivni korisnik ima mogućnost selektovanja pogleda v$session – grant komandom

grant select on V_$SESSION to scott;)

SQL> select sid, serial# from v$session where audsid= sys_context('userenv','sessionid');

SID SERIAL#

---------- ----------

159 11046

SQL> alter system kill session '154,42592';

System altered.

Prilikom pokusaja nastavka rada sesije dobija poruku:

USER is "SCOTT"

SQL> select * from dual;

select * from dual

ERROR at line 1:

ORA-00028: your session has been killed